using net_work.Data.Enum.Sys;

namespace net_work.Data.POCO.Sys;

public static class StudentExcelCells
{
    // 存储提示信息及其颜色
    public static readonly List<(string message, ExcelCellColor color)> TipMessages =
    [
        ("提示信息：在填写前，请先确保学院和行政班已正确设置！", ExcelCellColor.Black),
        ("请勿对模版的排版顺序进行修改，否则会导致导入失败！", ExcelCellColor.Red),
        ("标记为蓝色背景的列允许为空", ExcelCellColor.Blue),
        ("标记为红色背景的列值必须唯一", ExcelCellColor.Red)
    ];

    // 存储表头列及其颜色
    public static readonly List<(string columnHeader, ExcelCellColor color)> HeaderColumns =
    [
        ("姓名", ExcelCellColor.Black),
        ("性别", ExcelCellColor.Black),
        ("个人证件类型", ExcelCellColor.Black),
        ("证件号码", ExcelCellColor.Red),
        ("出生日期", ExcelCellColor.Blue),
        ("个人住址", ExcelCellColor.Blue),
        ("籍贯", ExcelCellColor.Blue),
        ("民族", ExcelCellColor.Blue),
        ("宗教信仰", ExcelCellColor.Blue),
        ("学生学号", ExcelCellColor.Red),
        ("所属行政班", ExcelCellColor.Black),
        ("学生学历", ExcelCellColor.Black),
        ("入学日期", ExcelCellColor.Blue),
        ("毕业日期", ExcelCellColor.Blue),
        ("紧急联系人姓名", ExcelCellColor.Blue),
        ("紧急联系人电话", ExcelCellColor.Blue),
        ("账号", ExcelCellColor.Red),
        ("密码", ExcelCellColor.Black),
        ("联系电话", ExcelCellColor.Red),
        ("邮箱（可以为空）", ExcelCellColor.Red)
    ];
}